alter proc [dbo].[SP_INS_CLIENT_APPOINTMENT]    
 @CLI_ID int OUTPUT ,
 @ACC_ID int ,   
 @CLI_NAME nvarchar(100) ,  
 @CLI_ADDRESS nvarchar(100) ,   
 @CLI_EMAIL nvarchar(200) ,   
 @CLI_PHONE int,  
  
 @APP_ID int OUTPUT ,  
 @EMP_ID int ,
@SPA_ID int ,    
 @SER_ID int ,
     
 @APP_DATE dateTime ,    
 @APP_STARTTIME dateTime ,  
 @APP_STATUS VARCHAR(5)          
as    
begin   
  insert into [CLIENTS] ( [ACC_ID] ,  [CLI_NAME] ,  [CLI_ADDRESS] ,  [CLI_EMAIL] ,  [CLI_PHONE] )    
  values  ( @ACC_ID ,  @CLI_NAME ,  @CLI_ADDRESS ,  @CLI_EMAIL ,  @CLI_PHONE )    
  set @CLI_ID= SCOPE_IDENTITY()   
    
  EXEC SP_INS_APPOINTMENTS_values @APP_ID,@EMP_ID,@CLI_ID,@SPA_ID,@SER_ID,@APP_DATE,@APP_STARTTIME,@APP_STATUS  
end 

sp_helptext SP_INS_APPOINTMENTS_values